Create  TABLE MAIN.[XXFP_MX](
[FPZL] char(1) NOT NULL
,[FPDM] varchar(10) NOT NULL
,[FPHM] int NOT NULL
,[FPMXXH] float NOT NULL
,[XSDJBH] varchar(20)
,[FPHXZ] int NOT NULL
,[JE] decimal NOT NULL
,[SLV] float
,[SE] decimal NOT NULL
,[SPMC] varchar(100) NOT NULL
,[SPSM] varchar(6)
,[GGXH] varchar(40)
,[JLDW] varchar(32)
,[SL] VARCHAR(21)
,[DJ] VARCHAR(21)
,[HSJBZ] bit NOT NULL
,[SPBH] varchar(16)
,[DJMXXH] int
,[FLBM] VARCHAR(19)
,[XSYH] INT(1)
,[YHSM] VARCHAR(500)
,[LSLVBS] VARCHAR(1)
, Primary Key(FPZL,FPDM,FPHM,FPMXXH)    , FOREIGN KEY ([FPZL],[FPDM],[FPHM])  REFERENCES [XXFP] ([FPZL],[FPDM],[FPHM]) On Delete CASCADE On Update CASCADE 

);

CREATE INDEX [MX_FPMXXH] ON [XXFP_MX] ([FPMXXH] ASC);
CREATE INDEX [MX_XSDJBH] ON [XXFP_MX] ([XSDJBH] ASC);
CREATE INDEX [MX_ZL_DM_HM] ON [XXFP_MX] ([FPZL], [FPDM], [FPHM]);
